package dirtyreads;
import java.sql.*;

public class T1 {
	public static void main(String[] args) throws Exception {
		Connection connection = DriverManager.getConnection("jdbc:pointbase:server://127.0.0.1/StaplerzDB", "PBPUBLIC", "PBPUBLIC");
		connection.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
		
		Statement query = connection.createStatement();
		ResultSet result = query.executeQuery("SELECT quantity FROM order_items WHERE sku='0001' AND orderid=1");
		while(result.next())
			System.out.println(result.getInt("quantity"));
		
		connection.close();
	}
}
